We have an "insert-update" stored procedure that is referenced by our ASP page (using "rs.open (SQLstring)&#34


If the stored proc inserts values in the table, it returns the Identity Value:
"
select @NewRowNum = @@IDENTITY
return @NewRowNum
"

When we execute the stored proc from the ASP, it actually inserts a new row in our table, but we cannot get the @NewRowNum...
Does anyone know how can we get this value in the ASP page from our recordset?

Thank you very much,
Anastasia.